/**
 * Copyright 2009 Emory University
 * 
 * Permission is hereby granted, free of charge, to any person obtaining a
 * copy of this software and associated  documentation files (the "Software"),
 * to deal in the Software without restriction, including without limitation
 * the rights to use, copy, modify, merge, publish, distribute, sublicense, 
 * and/or sell copies of the Software, and to permit persons to whom the 
 * Software is furnished to do so, subject to the following conditions: The 
 * above copyright notice and this permission notice shall be included in all 
 * copies or substantial portions of the Software. 
 * 
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING 
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
 * DEALINGS IN THE SOFTWARE.
 */
package com.markgrand.structuredSql.postgresql

import com.markgrand.structuredSql._

/**
 * Append an Insert statement with PostgreSQL extensions to a StringBuilder.
 * 
 * @author Mark Grand
 */
class PostgresqlInsert protected (override val table:TableName,
                                  override val columnNames:Seq[String],
                                  override val values:SQLInsertValueAppender,
                                  val returning:SelectList) extends Insert(table, columnNames, values) {
  override def append(builder:StringBuilder) {
    super.append(builder)
    if (returning != null) {
      builder.append(" RETURNING ")
      returning.append(builder)
    }
  }
}

object PostgresqlInsert {
  def apply(table:TableName, columnNames:Seq[String], values:SQLInsertValueAppender, returning:SelectList) = {
    new PostgresqlInsert(table, columnNames, values, returning)
  }
  
  def apply(tableName:String, columnNames:Seq[String], values:SQLInsertValueAppender, returning:SelectList) = {
    new PostgresqlInsert(TableName(tableName), columnNames, values, returning)
  }
}